{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Criteria","0.Source_Data","Index","Audit"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Criteria","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5]]}
["Criteria"]
["The below tables are formatted and organized as a source for the criteria that sorts the structures into the six categories. \nDo NOT delete."]
["Fracture Critical","(92A) Fracture Critical?"]
[null,{"$f":"\"Y\"","v":"Y"}]
[]
["Scour Critical","(113) Scour Critical 3 or U?"]
[null,{"$f":"\"Yes\"","v":"Yes"}]
[]
["Low NBI Condition","(58, 59, 60, 62) Lowest NBI Condition of Deck, Superstructure, Substructure, Culvert"]
[null,"<=4"]
[]
["Complex Bridge","Complex Bridge? (See list)"]
[null,{"$f":"\"Yes\"","v":"Yes"}]
[]
["NHS","(104) On NHS?"]
[null,{"$f":"\"NHS\"","v":"NHS"}]
[]
["Remaining","(92A) Fracture Critical?","(113) Scour Critical 3 or U?","(58, 59, 60, 62) Lowest NBI Condition of Deck, Superstructure, Substructure, Culvert","Complex Bridge? (See list)","(104) On NHS?"]
[null,"N","No",">=5","No","Not NHS"]
[]
["Summary","Bridge selected for QA?"]
[null,"Yes"]

{"sheet":"0.Source_Data","index":1,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","(8) Asset ID","(2) District","(3) County","(7) Facility Carried","(6) Feature Crossed","(27) Year Built","(92A) Fracture Critical?","(113) Scour Critical 3 or U?","(58, 59, 60, 62) Lowest NBI Condition of Deck, Superstructure, Substructure, Culvert","Complex Bridge? (See list)","(104) On NHS?","Site Assessment Performed","Load Rating Performed","Load Rating QC Completed","Signed Load Rating Package Submitted","Random Number for QA Selection","Bridge selected for QA?","QA Review Performed"]

{"sheet":"Index","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,0,5,3],[6,0,6,3]]}
[null,null,null,13]
[]
[]
[]
["Instructions:"]
["1. Copy Data from \"QC Load Rating Review Tracking Sheet\" (from multiple sources if necessary) and Paste (combine) to \"0.Source_Data\" Worksheet in this Workbook."]
["2. Run Macros by using the button.\nThis button runs the following macros:\n1. Macro \"StructureSorting\" - Sorts the data from the \"0.Source_Data\" tab into the 6 categories.\n2. Macro \"CreateSummarySheet\" - Creates a summary sheet that prints all of the structures selected for QA.\n3. Macro \"SetFormatting\" - Applies designated formatting. (Will prompt for a file location for the SCDOT logo image and PDF output save location.)"]

{"sheet":"Audit","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"User Name","Computer Name","Open Time","Close Time","Open WB Name","Close WB Name"]
[null,null,null,null,"2019-03-14T10:36:21",null,"C:\\Users\\mtrejo\\Documents\\Projects\\2019\\001_SCDOT\\02_Load Rating_Part 1\\LRGD Forms\\Template Guides\\A03.5_QA Load Rating Review Tracking Sheet Template.xlsm"]